﻿CREATE PROCEDURE [dbo].[Tournaments_SelectByIDWithChildren]
   @league_id uniqueidentifier,
   @tournament_name nvarchar (40)
AS
EXEC [dbo].[Tournaments_SelectByID] @league_id, @tournament_name
EXEC [dbo].[Tournament_Members_SelectByLeagueIdTournamentName] @league_id, @tournament_name


